package com.java.dao;

import java.sql.Connection;
import java.util.ArrayList;
import java.util.HashMap;

import com.java.util.DaoUtils;

public class Com0101lp04Dao extends CommonDao{
	
	public ArrayList execute(HashMap requestMap,Connection con) {

		ArrayList list = new ArrayList();
		try {

			String queryStr = "call com_com0101p04Insert(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";

			String param[] = new String[26];
			param[0] = (String) requestMap.get("member_id");
			param[1] = (String) requestMap.get("member_id");
			param[2] = (String) requestMap.get("ent_id");
			param[3] = (String) requestMap.get("dept_cd");
			param[4] = (String) requestMap.get("class_cd");
			param[5] = (String) requestMap.get("member_gb");;
			param[6] = (String) requestMap.get("fin_school");
			param[7] = (String) requestMap.get("retire_dt");
			param[8] = (String) requestMap.get("sms_rcv_yn");
			param[9] = (String) requestMap.get("login_id");
			param[10] = (String) requestMap.get("login_nm");
			param[11] = (String) requestMap.get("login_pw");
			param[12] = (String) requestMap.get("soc_no");
			param[13] = (String) requestMap.get("birth_dt");
			param[14] = (String) requestMap.get("solar_cal_gb");
			param[15] = (String) requestMap.get("norm_phone_no");
			param[16] = (String) requestMap.get("cell_phone_no");
			param[17] = (String) requestMap.get("email_id");
			param[18] = (String) requestMap.get("post_no");
			param[19] = (String) requestMap.get("post_addr");
			param[20] = (String) requestMap.get("detail_addr");
			param[21] = (String) requestMap.get("repl_id");
			param[22] = (String) requestMap.get("repl_dt");
			param[23] = (String) requestMap.get("check_gu");
			param[24] = (String) requestMap.get("service_end_dt");
			param[25] = (String) requestMap.get("start_login_dt");
			
			
			list = DaoUtils.select(con, queryStr, param);

		} catch (Exception ee) {
			ee.printStackTrace();
		}finally {
			try{
				if (con!=null) con.setAutoCommit(true);
				if (con!=null) con.close();
			}catch(Exception ee){}
		}
		return list;
	}
}
